create  sequence seq_subject

create table t_subject(
    no  number primary key,
    subject_name varchar2(1024),
    teacher_name varchar2(50),
    teacher_contact varchar2(120),
    sno varchar2(9),
    sname varchar2(50),
    status number


);

--初始化数据  课题
insert  into t_subject(no,subject_name,teacher_name,teacher_contact,status)values
(seq_subject.nextval,'基于SpringBoot的毕设抽题系统','张三丰','zhangsanfeng@itany.com',0);
insert  into t_subject(no,subject_name,teacher_name,teacher_contact,status)values
(seq_subject.nextval,'基于SpringBoot的疫情管理系统','张翠山','zhangcuishan@itany.com',0);
insert  into t_subject(no,subject_name,teacher_name,teacher_contact,status)values
(seq_subject.nextval,'基于SSM的Bug库跟踪系统','张无忌','zhangwuji@itany.com',0);
commit;

---模拟部分课题可能删除了，重新添加的， 序列 不工整

select  * from t_subject
update t_subject set no = 10  where no = 3 ;
commit;